How to: Control remote requests.
Solution:
Select 'Options...' from the 'Tools' menu and clear the 'Update Remote References' check box in the 'Options' dialog box.
1) Open the desired worksheet in Excel.
2) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
3) Click 'Calculation' tab.
4) Clear the 'Update Remote References' check box in the 'Workbook Options' group.
the 'Update Remote References' check box
5) Click 'OK'.
